package anbook.dao;

import java.util.List;

import anbook.dto.Board_picture;

public interface IBoardPictureDAO {
	Board_picture getBoardPicture(int idx);
	List<Board_picture> getBoardPictures(int idx);
	void deleteBoardPicture(Board_picture pic);
	void insertBoardPicture(List<Board_picture> list);
	void allDeleteBoardPicture(int idx);
	
	public static final String SQL_GET_PICTURE = "select * from board_picture where bp_id = ?";
	public static final String SQL_GET_PICTURES = "select * from board_picture where b_num = ? order by bp_id";
	public static final String SQL_DELETE_PICTURE = "delete from board_picture where b_num = ? and bp_id=?";
	public static final String SQL_INSERT_PICTURE = "insert into board_picture(b_num,pic_path) values(?,?)";
	public static final String SQL_ALLDELETE_BOARDPICTURE = "delete from board_picture where b_num=?";
}
